﻿IF (EXISTS(SELECT id from sysobjects where id=object_id('TblVoter')))
	DROP TABLE [dbo].[TblVoter]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TblVoter](
	[VoterID] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[FatherName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[DOB] [datetime] NULL,
	[Address] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[EmailID] [nvarchar](360) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[District] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Panchayat] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Ward] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Pincode] [int] NULL
) ON [PRIMARY]
